﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="HNCDataSet" targetNamespace="http://tempuri.org/HNCDataSet.xsd" xmlns:mstns="http://tempuri.org/HNCDataSet.xsd" xmlns="http://tempuri.org/HNCDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="HNCConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="HNCConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.HNCConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="HNC_DBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HNC_DBConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.HNC_DBConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MembersTableAdapter" GeneratorDataComponentClassName="MembersTableAdapter" Name="Members" UserDataComponentName="MembersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="HNC_DB.dbo.Members" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Members] WHERE (([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Members] ([Username], [Password], [Fullname], [Image], [Address], [Email], [Phone], [AddDate], [AddBy], [Role], [Status]) VALUES (@Username, @Password, @Fullname, @Image, @Address, @Email, @Phone, @AddDate, @AddBy, @Role, @Status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fullname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fullname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AddDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Username, Password, Fullname, Image, Address, Email, Phone, AddDate, AddBy, Role, Status FROM dbo.Members</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Members] SET [Username] = @Username, [Password] = @Password, [Fullname] = @Fullname, [Image] = @Image, [Address] = @Address, [Email] = @Email, [Phone] = @Phone, [AddDate] = @AddDate, [AddBy] = @AddBy, [Role] = @Role, [Status] = @Status WHERE (([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fullname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fullname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AddDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Fullname" DataSetColumn="Fullname" />
              <Mapping SourceColumn="Image" DataSetColumn="Image" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="AddDate" DataSetColumn="AddDate" />
              <Mapping SourceColumn="AddBy" DataSetColumn="AddBy" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="ChangePassword" Modifier="Public" Name="ChangePassword" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="ChangePassword">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       Members
SET                Password = @Password
WHERE        (Username = @Username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Password" ColumnName="Password" DataSourceName="HNC_DB.dbo.Members" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Username" ColumnName="Username" DataSourceName="HNC_DB.dbo.Members" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CheckLogin" Modifier="Public" Name="CheckLogin" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="CheckLogin">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*)
FROM            Members
WHERE        (Username = @Username) AND (Password = @Password) AND (Role = @Role) AND (Status = 1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Username" ColumnName="Username" DataSourceName="HNC_DB.dbo.Members" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Password" ColumnName="Password" DataSourceName="HNC_DB.dbo.Members" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Role" ColumnName="Role" DataSourceName="HNC_DB.dbo.Members" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CheckUsername" Modifier="Public" Name="CheckUsername" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="CheckUsername">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) 
FROM            Members
WHERE        (Username = @Username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Username" ColumnName="Username" DataSourceName="HNC_DB.dbo.Members" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CartTableAdapter" GeneratorDataComponentClassName="CartTableAdapter" Name="Cart" UserDataComponentName="CartTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="HNC_DB.dbo.Cart" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cart] WHERE (([CartID] = @Original_CartID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CartID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CartID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cart] ([Fulname], [Address], [Phone], [Email], [AddDate], [EditDate], [AddBy], [Description], [Paymethod], [Total], [Status]) VALUES (@Fulname, @Address, @Phone, @Email, @AddDate, @EditDate, @AddBy, @Description, @Paymethod, @Total, @Status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fulname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fulname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AddDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EditDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EditDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Paymethod" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Paymethod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Total" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CartID, Fulname, Address, Phone, Email, AddDate, EditDate, AddBy, Description, Paymethod, Total, Status FROM dbo.Cart</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cart] SET [Fulname] = @Fulname, [Address] = @Address, [Phone] = @Phone, [Email] = @Email, [AddDate] = @AddDate, [EditDate] = @EditDate, [AddBy] = @AddBy, [Description] = @Description, [Paymethod] = @Paymethod, [Total] = @Total, [Status] = @Status WHERE (([CartID] = @Original_CartID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fulname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fulname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AddDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EditDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EditDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Paymethod" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Paymethod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Total" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CartID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CartID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CartID" DataSetColumn="CartID" />
              <Mapping SourceColumn="Fulname" DataSetColumn="Fulname" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="AddDate" DataSetColumn="AddDate" />
              <Mapping SourceColumn="EditDate" DataSetColumn="EditDate" />
              <Mapping SourceColumn="AddBy" DataSetColumn="AddBy" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Paymethod" DataSetColumn="Paymethod" />
              <Mapping SourceColumn="Total" DataSetColumn="Total" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoryTableAdapter" GeneratorDataComponentClassName="CategoryTableAdapter" Name="Category" UserDataComponentName="CategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="HNC_DB.dbo.Category" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Category] WHERE (([CateID] = @Original_CateID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CateID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Category] ([Title], [Title_en], [Description], [Description_en], [Content], [Content_en], [Image], [ParentID], [AddDate], [AddBy], [Order], [Status], [SEOUrl]) VALUES (@Title, @Title_en, @Description, @Description_en, @Content, @Content_en, @Image, @ParentID, @AddDate, @AddBy, @Order, @Status, @SEOUrl)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title_en" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AddDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SEOUrl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SEOUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CateID, Title, Title_en, Description, Description_en, Content, Content_en, Image, ParentID, AddDate, AddBy, [Order], Status, SEOUrl FROM dbo.Category</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Category] SET [Title] = @Title, [Title_en] = @Title_en, [Description] = @Description, [Description_en] = @Description_en, [Content] = @Content, [Content_en] = @Content_en, [Image] = @Image, [ParentID] = @ParentID, [AddDate] = @AddDate, [AddBy] = @AddBy, [Order] = @Order, [Status] = @Status, [SEOUrl] = @SEOUrl WHERE (([CateID] = @Original_CateID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title_en" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AddDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SEOUrl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SEOUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CateID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CateID" DataSetColumn="CateID" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Title_en" DataSetColumn="Title_en" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Description_en" DataSetColumn="Description_en" />
              <Mapping SourceColumn="Content" DataSetColumn="Content" />
              <Mapping SourceColumn="Content_en" DataSetColumn="Content_en" />
              <Mapping SourceColumn="Image" DataSetColumn="Image" />
              <Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
              <Mapping SourceColumn="AddDate" DataSetColumn="AddDate" />
              <Mapping SourceColumn="AddBy" DataSetColumn="AddBy" />
              <Mapping SourceColumn="Order" DataSetColumn="Order" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="SEOUrl" DataSetColumn="SEOUrl" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="gre41bfd_xpfilm.dbo.Category" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCateByParentID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetCateByParentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCateByParentID" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        CateID, Title, Title_en, Description, Description_en, [Content], Content_en, Image, ParentID, AddDate, AddBy, [Order], Status, SEOUrl
FROM            dbo.Category
WHERE        (ParentID = @ParentID) AND (Status = 1)
ORDER BY [Order]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ParentID" ColumnName="ParentID" DataSourceName="gre41bfd_xpfilm.dbo.Category" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="sie43939_sieuthitoc.dbo.Category" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy1" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCateByCateID" GeneratorSourceName="FillBy1" GetMethodModifier="Public" GetMethodName="GetCateByCateID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCateByCateID" UserSourceName="FillBy1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        CateID, Title, Title_en, Description, Description_en, [Content], Content_en, Image, ParentID, AddDate, AddBy, [Order], Status, SEOUrl
FROM            dbo.Category
WHERE        (CateID = @CateID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CateID" ColumnName="CateID" DataSourceName="sie43939_sieuthitoc.dbo.Category" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CateID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="sie43939_sieuthitoc.dbo.Category" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy2" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByParentAll" GeneratorSourceName="FillBy2" GetMethodModifier="Public" GetMethodName="GetDataByParentAll" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByParentAll" UserSourceName="FillBy2">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        CateID, Title, Title_en, Description, Description_en, [Content], Content_en, Image, ParentID, AddDate, AddBy, [Order], Status, SEOUrl
FROM            dbo.Category
WHERE        (ParentID = @ParentID)
ORDER BY Status DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ParentID" ColumnName="ParentID" DataSourceName="sie43939_sieuthitoc.dbo.Category" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ParentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InfoTableAdapter" GeneratorDataComponentClassName="InfoTableAdapter" Name="Info" UserDataComponentName="InfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="HNC_DB.dbo.Info" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Info] WHERE (([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Info] ([Title], [Title_en], [Description], [Description_en], [Content], [Content_en], [Image], [Address], [Address_en], [Phone], [Email], [Yahoo], [Yahoo1], [Yahoo2], [Skype], [Skype1], [Skype2], [Facebook], [Facebook1], [Facebook2], [GooglePlus], [GooglePlus1], [GooglePlus2], [GoogleMap], [GoogleMap1], [GoogleMap2], [GoogleMap3], [Status]) VALUES (@Title, @Title_en, @Description, @Description_en, @Content, @Content_en, @Image, @Address, @Address_en, @Phone, @Email, @Yahoo, @Yahoo1, @Yahoo2, @Skype, @Skype1, @Skype2, @Facebook, @Facebook1, @Facebook2, @GooglePlus, @GooglePlus1, @GooglePlus2, @GoogleMap, @GoogleMap1, @GoogleMap2, @GoogleMap3, @Status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title_en" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address_en" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Yahoo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Yahoo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Yahoo1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Yahoo1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Yahoo2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Yahoo2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Skype" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Skype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Skype1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Skype1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Skype2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Skype2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Facebook" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Facebook" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Facebook1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Facebook1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Facebook2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Facebook2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GooglePlus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GooglePlus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GooglePlus1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GooglePlus1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GooglePlus2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GooglePlus2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoogleMap" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="GoogleMap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoogleMap1" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="GoogleMap1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoogleMap2" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="GoogleMap2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoogleMap3" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="GoogleMap3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Title, Title_en, Description, Description_en, Content, Content_en, Image, Address, Address_en, Phone, Email, Yahoo, Yahoo1, Yahoo2, Skype, Skype1, Skype2, Facebook, Facebook1, Facebook2, GooglePlus, GooglePlus1, GooglePlus2, GoogleMap, GoogleMap1, GoogleMap2, GoogleMap3, Status FROM dbo.Info</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Info] SET [Title] = @Title, [Title_en] = @Title_en, [Description] = @Description, [Description_en] = @Description_en, [Content] = @Content, [Content_en] = @Content_en, [Image] = @Image, [Address] = @Address, [Address_en] = @Address_en, [Phone] = @Phone, [Email] = @Email, [Yahoo] = @Yahoo, [Yahoo1] = @Yahoo1, [Yahoo2] = @Yahoo2, [Skype] = @Skype, [Skype1] = @Skype1, [Skype2] = @Skype2, [Facebook] = @Facebook, [Facebook1] = @Facebook1, [Facebook2] = @Facebook2, [GooglePlus] = @GooglePlus, [GooglePlus1] = @GooglePlus1, [GooglePlus2] = @GooglePlus2, [GoogleMap] = @GoogleMap, [GoogleMap1] = @GoogleMap1, [GoogleMap2] = @GoogleMap2, [GoogleMap3] = @GoogleMap3, [Status] = @Status WHERE (([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title_en" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address_en" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Yahoo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Yahoo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Yahoo1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Yahoo1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Yahoo2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Yahoo2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Skype" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Skype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Skype1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Skype1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Skype2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Skype2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Facebook" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Facebook" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Facebook1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Facebook1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Facebook2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Facebook2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GooglePlus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GooglePlus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GooglePlus1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GooglePlus1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GooglePlus2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GooglePlus2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoogleMap" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="GoogleMap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoogleMap1" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="GoogleMap1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoogleMap2" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="GoogleMap2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GoogleMap3" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="GoogleMap3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Title_en" DataSetColumn="Title_en" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Description_en" DataSetColumn="Description_en" />
              <Mapping SourceColumn="Content" DataSetColumn="Content" />
              <Mapping SourceColumn="Content_en" DataSetColumn="Content_en" />
              <Mapping SourceColumn="Image" DataSetColumn="Image" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="Address_en" DataSetColumn="Address_en" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Yahoo" DataSetColumn="Yahoo" />
              <Mapping SourceColumn="Yahoo1" DataSetColumn="Yahoo1" />
              <Mapping SourceColumn="Yahoo2" DataSetColumn="Yahoo2" />
              <Mapping SourceColumn="Skype" DataSetColumn="Skype" />
              <Mapping SourceColumn="Skype1" DataSetColumn="Skype1" />
              <Mapping SourceColumn="Skype2" DataSetColumn="Skype2" />
              <Mapping SourceColumn="Facebook" DataSetColumn="Facebook" />
              <Mapping SourceColumn="Facebook1" DataSetColumn="Facebook1" />
              <Mapping SourceColumn="Facebook2" DataSetColumn="Facebook2" />
              <Mapping SourceColumn="GooglePlus" DataSetColumn="GooglePlus" />
              <Mapping SourceColumn="GooglePlus1" DataSetColumn="GooglePlus1" />
              <Mapping SourceColumn="GooglePlus2" DataSetColumn="GooglePlus2" />
              <Mapping SourceColumn="GoogleMap" DataSetColumn="GoogleMap" />
              <Mapping SourceColumn="GoogleMap1" DataSetColumn="GoogleMap1" />
              <Mapping SourceColumn="GoogleMap2" DataSetColumn="GoogleMap2" />
              <Mapping SourceColumn="GoogleMap3" DataSetColumn="GoogleMap3" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="HNC_DB.dbo.Info" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetInfoByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetInfoByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetInfoByID" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, Address_en, [Content], Content_en, Description, Description_en, Email, Facebook, Facebook1, Facebook2, GoogleMap, GoogleMap1, GoogleMap2, GoogleMap3, GooglePlus, GooglePlus1, GooglePlus2, ID, Image, Phone, Skype, Skype1, Skype2, Status, Title, Title_en, Yahoo, Yahoo1, Yahoo2 FROM Info WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="HNC_DB.dbo.Info" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductInCartTableAdapter" GeneratorDataComponentClassName="ProductInCartTableAdapter" Name="ProductInCart" UserDataComponentName="ProductInCartTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="HNC_DB.dbo.ProductInCart" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ProductInCart] WHERE (([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ProductInCart] ([CartID], [ProductID], [Quantity]) VALUES (@CartID, @ProductID, @Quantity)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CartID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CartID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, CartID, ProductID, Quantity FROM dbo.ProductInCart</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ProductInCart] SET [CartID] = @CartID, [ProductID] = @ProductID, [Quantity] = @Quantity WHERE (([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CartID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CartID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="CartID" DataSetColumn="CartID" />
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="HNC_DB.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Products] WHERE (([ProductID] = @Original_ProductID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Products] ([Code], [Title], [Title_en], [Description], [Description_en], [Content], [Content_en], [Image], [Link], [VideoUrl], [Price], [PriceSale], [CateID], [AddDate], [Editdate], [AddBy], [New], [Vip], [Sale], [MetaTitle], [MetaDescription], [MetaKeywork], [MetaRobots], [Order], [Status], [Delete]) VALUES (@Code, @Title, @Title_en, @Description, @Description_en, @Content, @Content_en, @Image, @Link, @VideoUrl, @Price, @PriceSale, @CateID, @AddDate, @Editdate, @AddBy, @New, @Vip, @Sale, @MetaTitle, @MetaDescription, @MetaKeywork, @MetaRobots, @Order, @Status, @Delete)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title_en" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Link" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Link" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VideoUrl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VideoUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PriceSale" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PriceSale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CateID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AddDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Editdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Editdate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@New" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="New" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Vip" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Vip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Sale" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Sale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MetaTitle" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MetaTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MetaDescription" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MetaDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MetaKeywork" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MetaKeywork" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MetaRobots" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MetaRobots" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Delete" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Delete" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ProductID, Code, Title, Title_en, Description, Description_en, Content, Content_en, Image, Link, VideoUrl, Price, PriceSale, CateID, AddDate, Editdate, AddBy, New, Vip, Sale, MetaTitle, MetaDescription, MetaKeywork, MetaRobots, [Order], Status, [Delete] FROM dbo.Products</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Products] SET [Code] = @Code, [Title] = @Title, [Title_en] = @Title_en, [Description] = @Description, [Description_en] = @Description_en, [Content] = @Content, [Content_en] = @Content_en, [Image] = @Image, [Link] = @Link, [VideoUrl] = @VideoUrl, [Price] = @Price, [PriceSale] = @PriceSale, [CateID] = @CateID, [AddDate] = @AddDate, [Editdate] = @Editdate, [AddBy] = @AddBy, [New] = @New, [Vip] = @Vip, [Sale] = @Sale, [MetaTitle] = @MetaTitle, [MetaDescription] = @MetaDescription, [MetaKeywork] = @MetaKeywork, [MetaRobots] = @MetaRobots, [Order] = @Order, [Status] = @Status, [Delete] = @Delete WHERE (([ProductID] = @Original_ProductID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title_en" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Content_en" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Content_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Link" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Link" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VideoUrl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VideoUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PriceSale" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PriceSale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CateID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AddDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Editdate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Editdate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AddBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AddBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@New" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="New" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Vip" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Vip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Sale" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Sale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MetaTitle" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MetaTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MetaDescription" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MetaDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MetaKeywork" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MetaKeywork" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MetaRobots" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="MetaRobots" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Delete" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Delete" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Title_en" DataSetColumn="Title_en" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Description_en" DataSetColumn="Description_en" />
              <Mapping SourceColumn="Content" DataSetColumn="Content" />
              <Mapping SourceColumn="Content_en" DataSetColumn="Content_en" />
              <Mapping SourceColumn="Image" DataSetColumn="Image" />
              <Mapping SourceColumn="Link" DataSetColumn="Link" />
              <Mapping SourceColumn="VideoUrl" DataSetColumn="VideoUrl" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
              <Mapping SourceColumn="PriceSale" DataSetColumn="PriceSale" />
              <Mapping SourceColumn="CateID" DataSetColumn="CateID" />
              <Mapping SourceColumn="AddDate" DataSetColumn="AddDate" />
              <Mapping SourceColumn="Editdate" DataSetColumn="Editdate" />
              <Mapping SourceColumn="AddBy" DataSetColumn="AddBy" />
              <Mapping SourceColumn="New" DataSetColumn="New" />
              <Mapping SourceColumn="Vip" DataSetColumn="Vip" />
              <Mapping SourceColumn="Sale" DataSetColumn="Sale" />
              <Mapping SourceColumn="MetaTitle" DataSetColumn="MetaTitle" />
              <Mapping SourceColumn="MetaDescription" DataSetColumn="MetaDescription" />
              <Mapping SourceColumn="MetaKeywork" DataSetColumn="MetaKeywork" />
              <Mapping SourceColumn="MetaRobots" DataSetColumn="MetaRobots" />
              <Mapping SourceColumn="Order" DataSetColumn="Order" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="Delete" DataSetColumn="Delete" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteProductByProductID" Modifier="Public" Name="DeleteProductByProductID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteProductByProductID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       Products
SET                [Delete] = @Delete
WHERE        (ProductID = @Original_ProductID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Delete" ColumnName="Delete" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Delete" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Delete" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ProductID" ColumnName="ProductID" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="gre41bfd_xpfilm.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetProductByCateID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetProductByCateID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetProductByCateID" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ProductID, Code, Title, Title_en, Description, Description_en, [Content], Content_en, Image, Link, VideoUrl, Price, PriceSale, CateID, AddDate, Editdate, AddBy, 
                         New, Vip, Sale, MetaTitle, MetaDescription, MetaKeywork, MetaRobots, [Order], Status, [Delete]
FROM            dbo.Products
WHERE        (CateID = @CateID) AND ([Delete] = 0) AND (Status = 1)
ORDER BY [Order], Editdate DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CateID" ColumnName="CateID" DataSourceName="gre41bfd_xpfilm.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CateID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBy1" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetProducts" GeneratorSourceName="FillBy1" GetMethodModifier="Public" GetMethodName="GetProducts" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetProducts" UserSourceName="FillBy1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Products.ProductID, Products.Code, Products.Title, Products.Title_en, Products.Description, Products.Description_en, Products.[Content], Products.Content_en, 
                         Products.Image, Products.Link, Products.VideoUrl, Products.Price, Products.PriceSale, Products.CateID, Products.AddDate, Products.Editdate, Products.AddBy, 
                         Products.New, Products.Vip, Products.Sale, Products.MetaTitle, Products.MetaDescription, Products.MetaKeywork, Products.MetaRobots, Products.[Order], 
                         Products.Status, Products.[Delete], Category.ParentID, Category.Title AS Expr1, Category.Title_en AS Expr2
FROM            Products INNER JOIN
                         Category ON Products.CateID = Category.CateID
WHERE        (Products.[Delete] = 0) AND (Category.ParentID = 3)
ORDER BY Products.Editdate DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="gre41bfd_xpfilm.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy10" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetVip" GeneratorSourceName="FillBy10" GetMethodModifier="Public" GetMethodName="GetVip" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetVip" UserSourceName="FillBy10">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ProductID, Code, Title, Title_en, Description, Description_en, [Content], Content_en, Image, Link, VideoUrl, Price, PriceSale, CateID, AddDate, Editdate, AddBy, 
                         New, Vip, Sale, MetaTitle, MetaDescription, MetaKeywork, MetaRobots, [Order], Status, [Delete]
FROM            dbo.Products
WHERE        (Vip = 1) AND (Status = 1) AND ([Delete] = 0)
ORDER BY [Order], Editdate DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBy11" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetService" GeneratorSourceName="FillBy11" GetMethodModifier="Public" GetMethodName="GetService" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetService" UserSourceName="FillBy11">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Products.ProductID, Products.Code, Products.Title, Products.Title_en, Products.Description, Products.Description_en, Products.[Content], Products.Content_en, 
                         Products.Image, Products.Link, Products.VideoUrl, Products.Price, Products.PriceSale, Products.CateID, Products.AddDate, Products.Editdate, Products.AddBy, 
                         Products.New, Products.Vip, Products.Sale, Products.MetaTitle, Products.MetaDescription, Products.MetaKeywork, Products.MetaRobots, Products.[Order], 
                         Products.Status, Products.[Delete], Category.ParentID, Category.Title AS Expr1, Category.Title_en AS Expr2
FROM            Products INNER JOIN
                         Category ON Products.CateID = Category.CateID
WHERE        (Products.[Delete] = 0) AND (Category.ParentID = 7)
ORDER BY Products.Editdate DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBy2" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetNews" GeneratorSourceName="FillBy2" GetMethodModifier="Public" GetMethodName="GetNews" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetNews" UserSourceName="FillBy2">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Products.ProductID, Products.Code, Products.Title, Products.Title_en, Products.Description, Products.Description_en, Products.[Content], Products.Content_en, 
                         Products.Image, Products.Link, Products.VideoUrl, Products.Price, Products.PriceSale, Products.CateID, Products.AddDate, Products.Editdate, Products.AddBy, 
                         Products.New, Products.Vip, Products.Sale, Products.MetaTitle, Products.MetaDescription, Products.MetaKeywork, Products.MetaRobots, Products.[Order], 
                         Products.Status, Products.[Delete], Category.ParentID, Category.Title AS Expr1, Category.Title_en AS Expr2
FROM            Products INNER JOIN
                         Category ON Products.CateID = Category.CateID
WHERE        (Products.[Delete] = 0) AND (Category.ParentID = 4)
ORDER BY Products.Editdate DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="HNC_DB.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy3" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetProductByProductID" GeneratorSourceName="FillBy3" GetMethodModifier="Public" GetMethodName="GetProductByProductID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetProductByProductID" UserSourceName="FillBy3">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ProductID, Code, Title, Title_en, Description, Description_en, [Content], Content_en, Image, Link, VideoUrl, Price, PriceSale, CateID, AddDate, Editdate, AddBy, New, 
                         Vip, Sale, MetaTitle, MetaDescription, MetaKeywork, MetaRobots, [Order], Status, [Delete]
FROM            Products
WHERE        (ProductID = @ProductID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBy4" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetProductsVip" GeneratorSourceName="FillBy4" GetMethodModifier="Public" GetMethodName="GetProductsVip" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetProductsVip" UserSourceName="FillBy4">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Products.ProductID, Products.Code, Products.Title, Products.Title_en, Products.Description, Products.Description_en, Products.[Content], Products.Content_en, 
                         Products.Image, Products.Link, Products.VideoUrl, Products.Price, Products.PriceSale, Products.CateID, Products.AddDate, Products.Editdate, Products.AddBy, 
                         Products.New, Products.Vip, Products.Sale, Products.MetaTitle, Products.MetaDescription, Products.MetaKeywork, Products.MetaRobots, Products.[Order], 
                         Products.Status, Products.[Delete], Category.ParentID, Category.Title AS Expr1, Category.Title_en AS Expr2
FROM            Products INNER JOIN
                         Category ON Products.CateID = Category.CateID
WHERE        (Products.[Delete] = 0) AND (Category.ParentID = 3) AND (Products.Vip = 1) AND (Products.Status = 1)
ORDER BY Products.[Order]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBy5" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetByNews" GeneratorSourceName="FillBy5" GetMethodModifier="Public" GetMethodName="GetByNews" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetByNews" UserSourceName="FillBy5">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Products.ProductID, Products.Code, Products.Title, Products.Title_en, Products.Description, Products.Description_en, Products.[Content], Products.Content_en, 
                         Products.Image, Products.Link, Products.VideoUrl, Products.Price, Products.PriceSale, Products.CateID, Products.AddDate, Products.Editdate, Products.AddBy, 
                         Products.New, Products.Vip, Products.Sale, Products.MetaTitle, Products.MetaDescription, Products.MetaKeywork, Products.MetaRobots, Products.[Order], 
                         Products.Status, Products.[Delete], Category.ParentID, Category.Title AS Expr1, Category.Title_en AS Expr2
FROM            Products INNER JOIN
                         Category ON Products.CateID = Category.CateID
WHERE        (Products.[Delete] = 0) AND (Category.ParentID = 4)
ORDER BY Products.Editdate DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="gre41bfd_xpfilm.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy6" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetProductByCateIDTop" GeneratorSourceName="FillBy6" GetMethodModifier="Public" GetMethodName="GetProductByCateIDTop" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetProductByCateIDTop" UserSourceName="FillBy6">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TOP (@Top) ProductID, Code, Title, Title_en, Description, Description_en, [Content], Content_en, Image, Link, VideoUrl, Price, PriceSale, CateID, AddDate, 
                         Editdate, AddBy, New, Vip, Sale, MetaTitle, MetaDescription, MetaKeywork, MetaRobots, [Order], Status, [Delete]
FROM            Products
WHERE        (CateID = @CateID) AND ([Delete] = 0) AND (Status = 1) AND (Vip = 1)
ORDER BY [Order], Editdate DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Top" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@Top" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CateID" ColumnName="CateID" DataSourceName="gre41bfd_xpfilm.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CateID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="XPFilm.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy7" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetProductReference" GeneratorSourceName="FillBy7" GetMethodModifier="Public" GetMethodName="GetProductReference" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetProductReference" UserSourceName="FillBy7">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ProductID, Code, Title, Title_en, Description, Description_en, [Content], Content_en, Image, Link, VideoUrl, Price, PriceSale, CateID, AddDate, Editdate, AddBy, 
                         New, Vip, Sale, MetaTitle, MetaDescription, MetaKeywork, MetaRobots, [Order], Status, [Delete]
FROM            Products
WHERE        (CateID = @CateID) AND ([Delete] = 0) AND (Status = 1) AND (Vip = 1) AND (ProductID &lt;&gt; @ProductID)
ORDER BY [Order], Editdate DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CateID" ColumnName="CateID" DataSourceName="XPFilm.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CateID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="XPFilm.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="XPFilm.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy8" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetSale" GeneratorSourceName="FillBy8" GetMethodModifier="Public" GetMethodName="GetSale" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetSale" UserSourceName="FillBy8">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ProductID, Code, Title, Title_en, Description, Description_en, [Content], Content_en, Image, Link, VideoUrl, Price, PriceSale, CateID, AddDate, Editdate, AddBy, 
                         New, Vip, Sale, MetaTitle, MetaDescription, MetaKeywork, MetaRobots, [Order], Status, [Delete]
FROM            Products
WHERE        (CateID = @CateID) AND (Sale = 1) AND ([Delete] = 0) AND (Status = 1)
ORDER BY [Order], Editdate DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CateID" ColumnName="CateID" DataSourceName="XPFilm.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CateID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="gre41bfd_xpfilm.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy9" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetSlider" GeneratorSourceName="FillBy9" GetMethodModifier="Public" GetMethodName="GetSlider" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetSlider" UserSourceName="FillBy9">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ProductID, Code, Title, Title_en, Description, Description_en, [Content], Content_en, Image, Link, VideoUrl, Price, PriceSale, CateID, AddDate, Editdate, AddBy, 
                         New, Vip, Sale, MetaTitle, MetaDescription, MetaKeywork, MetaRobots, [Order], Status, [Delete]
FROM            dbo.Products
WHERE        (Sale = 1) AND (Status = 1) AND ([Delete] = 0)
ORDER BY [Order], Editdate DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="HNC_DBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateProductByCateID" Modifier="Public" Name="UpdateProductByCateID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateProductByCateID">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       Products
SET                Code = @Code, Title = @Title, Title_en = @Title_en, Description = @Description, Description_en = @Description_en, [Content] = @Content, 
                         Content_en = @Content_en, Image = @Image, Link = @Link, VideoUrl = @VideoUrl, Price = @Price, PriceSale = @PriceSale, CateID = @CateID, AddDate = @AddDate,
                          Editdate = @Editdate, AddBy = @AddBy, New = @New, Vip = @Vip, Sale = @Sale, MetaTitle = @MetaTitle, MetaDescription = @MetaDescription, 
                         MetaKeywork = @MetaKeywork, MetaRobots = @MetaRobots, [Order] = @Order, Status = @Status, [Delete] = @Delete
WHERE        (CateID = @CateID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Code" ColumnName="Code" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Code" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Title" ColumnName="Title" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Title_en" ColumnName="Title_en" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Title_en" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Title_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Description" ColumnName="Description" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="ntext" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Description_en" ColumnName="Description_en" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="ntext" DbType="String" Direction="Input" ParameterName="@Description_en" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Content" ColumnName="Content" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="ntext" DbType="String" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Content" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Content_en" ColumnName="Content_en" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="ntext" DbType="String" Direction="Input" ParameterName="@Content_en" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Content_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Image" ColumnName="Image" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Link" ColumnName="Link" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@Link" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="Link" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="VideoUrl" ColumnName="VideoUrl" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@VideoUrl" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="VideoUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Price" ColumnName="Price" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Float" Scale="0" Size="8" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PriceSale" ColumnName="PriceSale" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@PriceSale" Precision="0" ProviderType="Float" Scale="0" Size="8" SourceColumn="PriceSale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CateID" ColumnName="CateID" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CateID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CateID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AddDate" ColumnName="AddDate" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@AddDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Editdate" ColumnName="Editdate" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Editdate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="Editdate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AddBy" ColumnName="AddBy" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="nvarchar(MAX)" DbType="String" Direction="Input" ParameterName="@AddBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumn="AddBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="New" ColumnName="New" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@New" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="New" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Vip" ColumnName="Vip" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Vip" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Vip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Sale" ColumnName="Sale" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Sale" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Sale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MetaTitle" ColumnName="MetaTitle" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="ntext" DbType="String" Direction="Input" ParameterName="@MetaTitle" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="MetaTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MetaDescription" ColumnName="MetaDescription" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="ntext" DbType="String" Direction="Input" ParameterName="@MetaDescription" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="MetaDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MetaKeywork" ColumnName="MetaKeywork" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="ntext" DbType="String" Direction="Input" ParameterName="@MetaKeywork" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="MetaKeywork" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MetaRobots" ColumnName="MetaRobots" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="ntext" DbType="String" Direction="Input" ParameterName="@MetaRobots" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="MetaRobots" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Order" ColumnName="Order" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Status" ColumnName="Status" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Delete" ColumnName="Delete" DataSourceName="HNC_DB.dbo.Products" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Delete" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Delete" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="HNCDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="HNCDataSet" msprop:Generator_UserDSName="HNCDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Members" msprop:Generator_TableClassName="MembersDataTable" msprop:Generator_TableVarName="tableMembers" msprop:Generator_RowChangedName="MembersRowChanged" msprop:Generator_TablePropName="Members" msprop:Generator_RowDeletingName="MembersRowDeleting" msprop:Generator_RowChangingName="MembersRowChanging" msprop:Generator_RowEvHandlerName="MembersRowChangeEventHandler" msprop:Generator_RowDeletedName="MembersRowDeleted" msprop:Generator_RowClassName="MembersRow" msprop:Generator_UserTableName="Members" msprop:Generator_RowEvArgName="MembersRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_UserColumnName="Username" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fullname" msprop:Generator_ColumnVarNameInTable="columnFullname" msprop:Generator_ColumnPropNameInRow="Fullname" msprop:Generator_ColumnPropNameInTable="FullnameColumn" msprop:Generator_UserColumnName="Fullname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddDate" msprop:Generator_ColumnVarNameInTable="columnAddDate" msprop:Generator_ColumnPropNameInRow="AddDate" msprop:Generator_ColumnPropNameInTable="AddDateColumn" msprop:Generator_UserColumnName="AddDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AddBy" msprop:Generator_ColumnVarNameInTable="columnAddBy" msprop:Generator_ColumnPropNameInRow="AddBy" msprop:Generator_ColumnPropNameInTable="AddByColumn" msprop:Generator_UserColumnName="AddBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Role" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_UserColumnName="Role" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Cart" msprop:Generator_TableClassName="CartDataTable" msprop:Generator_TableVarName="tableCart" msprop:Generator_TablePropName="Cart" msprop:Generator_RowDeletingName="CartRowDeleting" msprop:Generator_RowChangingName="CartRowChanging" msprop:Generator_RowEvHandlerName="CartRowChangeEventHandler" msprop:Generator_RowDeletedName="CartRowDeleted" msprop:Generator_UserTableName="Cart" msprop:Generator_RowChangedName="CartRowChanged" msprop:Generator_RowEvArgName="CartRowChangeEvent" msprop:Generator_RowClassName="CartRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CartID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCartID" msprop:Generator_ColumnPropNameInRow="CartID" msprop:Generator_ColumnPropNameInTable="CartIDColumn" msprop:Generator_UserColumnName="CartID" type="xs:int" />
              <xs:element name="Fulname" msprop:Generator_ColumnVarNameInTable="columnFulname" msprop:Generator_ColumnPropNameInRow="Fulname" msprop:Generator_ColumnPropNameInTable="FulnameColumn" msprop:Generator_UserColumnName="Fulname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddDate" msprop:Generator_ColumnVarNameInTable="columnAddDate" msprop:Generator_ColumnPropNameInRow="AddDate" msprop:Generator_ColumnPropNameInTable="AddDateColumn" msprop:Generator_UserColumnName="AddDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EditDate" msprop:Generator_ColumnVarNameInTable="columnEditDate" msprop:Generator_ColumnPropNameInRow="EditDate" msprop:Generator_ColumnPropNameInTable="EditDateColumn" msprop:Generator_UserColumnName="EditDate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddBy" msprop:Generator_ColumnVarNameInTable="columnAddBy" msprop:Generator_ColumnPropNameInRow="AddBy" msprop:Generator_ColumnPropNameInTable="AddByColumn" msprop:Generator_UserColumnName="AddBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Paymethod" msprop:Generator_ColumnVarNameInTable="columnPaymethod" msprop:Generator_ColumnPropNameInRow="Paymethod" msprop:Generator_ColumnPropNameInTable="PaymethodColumn" msprop:Generator_UserColumnName="Paymethod" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Total" msprop:Generator_ColumnVarNameInTable="columnTotal" msprop:Generator_ColumnPropNameInRow="Total" msprop:Generator_ColumnPropNameInTable="TotalColumn" msprop:Generator_UserColumnName="Total" type="xs:double" minOccurs="0" />
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Category" msprop:Generator_TableClassName="CategoryDataTable" msprop:Generator_TableVarName="tableCategory" msprop:Generator_TablePropName="Category" msprop:Generator_RowDeletingName="CategoryRowDeleting" msprop:Generator_RowChangingName="CategoryRowChanging" msprop:Generator_RowEvHandlerName="CategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="CategoryRowDeleted" msprop:Generator_UserTableName="Category" msprop:Generator_RowChangedName="CategoryRowChanged" msprop:Generator_RowEvArgName="CategoryRowChangeEvent" msprop:Generator_RowClassName="CategoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CateID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCateID" msprop:Generator_ColumnPropNameInRow="CateID" msprop:Generator_ColumnPropNameInTable="CateIDColumn" msprop:Generator_UserColumnName="CateID" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title_en" msprop:Generator_ColumnVarNameInTable="columnTitle_en" msprop:Generator_ColumnPropNameInRow="Title_en" msprop:Generator_ColumnPropNameInTable="Title_enColumn" msprop:Generator_UserColumnName="Title_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_en" msprop:Generator_ColumnVarNameInTable="columnDescription_en" msprop:Generator_ColumnPropNameInRow="Description_en" msprop:Generator_ColumnPropNameInTable="Description_enColumn" msprop:Generator_UserColumnName="Description_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Content" msprop:Generator_ColumnVarNameInTable="columnContent" msprop:Generator_ColumnPropNameInRow="Content" msprop:Generator_ColumnPropNameInTable="ContentColumn" msprop:Generator_UserColumnName="Content" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Content_en" msprop:Generator_ColumnVarNameInTable="columnContent_en" msprop:Generator_ColumnPropNameInRow="Content_en" msprop:Generator_ColumnPropNameInTable="Content_enColumn" msprop:Generator_UserColumnName="Content_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ParentID" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" msprop:Generator_UserColumnName="ParentID" type="xs:int" minOccurs="0" />
              <xs:element name="AddDate" msprop:Generator_ColumnVarNameInTable="columnAddDate" msprop:Generator_ColumnPropNameInRow="AddDate" msprop:Generator_ColumnPropNameInTable="AddDateColumn" msprop:Generator_UserColumnName="AddDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AddBy" msprop:Generator_ColumnVarNameInTable="columnAddBy" msprop:Generator_ColumnPropNameInRow="AddBy" msprop:Generator_ColumnPropNameInTable="AddByColumn" msprop:Generator_UserColumnName="AddBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Order" msprop:Generator_ColumnVarNameInTable="columnOrder" msprop:Generator_ColumnPropNameInRow="Order" msprop:Generator_ColumnPropNameInTable="OrderColumn" msprop:Generator_UserColumnName="Order" type="xs:int" minOccurs="0" />
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" type="xs:boolean" minOccurs="0" />
              <xs:element name="SEOUrl" msprop:Generator_ColumnVarNameInTable="columnSEOUrl" msprop:Generator_ColumnPropNameInRow="SEOUrl" msprop:Generator_ColumnPropNameInTable="SEOUrlColumn" msprop:Generator_UserColumnName="SEOUrl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Info" msprop:Generator_TableClassName="InfoDataTable" msprop:Generator_TableVarName="tableInfo" msprop:Generator_TablePropName="Info" msprop:Generator_RowDeletingName="InfoRowDeleting" msprop:Generator_RowChangingName="InfoRowChanging" msprop:Generator_RowEvHandlerName="InfoRowChangeEventHandler" msprop:Generator_RowDeletedName="InfoRowDeleted" msprop:Generator_UserTableName="Info" msprop:Generator_RowChangedName="InfoRowChanged" msprop:Generator_RowEvArgName="InfoRowChangeEvent" msprop:Generator_RowClassName="InfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title_en" msprop:Generator_ColumnVarNameInTable="columnTitle_en" msprop:Generator_ColumnPropNameInRow="Title_en" msprop:Generator_ColumnPropNameInTable="Title_enColumn" msprop:Generator_UserColumnName="Title_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_en" msprop:Generator_ColumnVarNameInTable="columnDescription_en" msprop:Generator_ColumnPropNameInRow="Description_en" msprop:Generator_ColumnPropNameInTable="Description_enColumn" msprop:Generator_UserColumnName="Description_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Content" msprop:Generator_ColumnVarNameInTable="columnContent" msprop:Generator_ColumnPropNameInRow="Content" msprop:Generator_ColumnPropNameInTable="ContentColumn" msprop:Generator_UserColumnName="Content" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Content_en" msprop:Generator_ColumnVarNameInTable="columnContent_en" msprop:Generator_ColumnPropNameInRow="Content_en" msprop:Generator_ColumnPropNameInTable="Content_enColumn" msprop:Generator_UserColumnName="Content_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address_en" msprop:Generator_ColumnVarNameInTable="columnAddress_en" msprop:Generator_ColumnPropNameInRow="Address_en" msprop:Generator_ColumnPropNameInTable="Address_enColumn" msprop:Generator_UserColumnName="Address_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Yahoo" msprop:Generator_ColumnVarNameInTable="columnYahoo" msprop:Generator_ColumnPropNameInRow="Yahoo" msprop:Generator_ColumnPropNameInTable="YahooColumn" msprop:Generator_UserColumnName="Yahoo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Yahoo1" msprop:Generator_ColumnVarNameInTable="columnYahoo1" msprop:Generator_ColumnPropNameInRow="Yahoo1" msprop:Generator_ColumnPropNameInTable="Yahoo1Column" msprop:Generator_UserColumnName="Yahoo1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Yahoo2" msprop:Generator_ColumnVarNameInTable="columnYahoo2" msprop:Generator_ColumnPropNameInRow="Yahoo2" msprop:Generator_ColumnPropNameInTable="Yahoo2Column" msprop:Generator_UserColumnName="Yahoo2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Skype" msprop:Generator_ColumnVarNameInTable="columnSkype" msprop:Generator_ColumnPropNameInRow="Skype" msprop:Generator_ColumnPropNameInTable="SkypeColumn" msprop:Generator_UserColumnName="Skype" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Skype1" msprop:Generator_ColumnVarNameInTable="columnSkype1" msprop:Generator_ColumnPropNameInRow="Skype1" msprop:Generator_ColumnPropNameInTable="Skype1Column" msprop:Generator_UserColumnName="Skype1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Skype2" msprop:Generator_ColumnVarNameInTable="columnSkype2" msprop:Generator_ColumnPropNameInRow="Skype2" msprop:Generator_ColumnPropNameInTable="Skype2Column" msprop:Generator_UserColumnName="Skype2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Facebook" msprop:Generator_ColumnVarNameInTable="columnFacebook" msprop:Generator_ColumnPropNameInRow="Facebook" msprop:Generator_ColumnPropNameInTable="FacebookColumn" msprop:Generator_UserColumnName="Facebook" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Facebook1" msprop:Generator_ColumnVarNameInTable="columnFacebook1" msprop:Generator_ColumnPropNameInRow="Facebook1" msprop:Generator_ColumnPropNameInTable="Facebook1Column" msprop:Generator_UserColumnName="Facebook1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Facebook2" msprop:Generator_ColumnVarNameInTable="columnFacebook2" msprop:Generator_ColumnPropNameInRow="Facebook2" msprop:Generator_ColumnPropNameInTable="Facebook2Column" msprop:Generator_UserColumnName="Facebook2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GooglePlus" msprop:Generator_ColumnVarNameInTable="columnGooglePlus" msprop:Generator_ColumnPropNameInRow="GooglePlus" msprop:Generator_ColumnPropNameInTable="GooglePlusColumn" msprop:Generator_UserColumnName="GooglePlus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GooglePlus1" msprop:Generator_ColumnVarNameInTable="columnGooglePlus1" msprop:Generator_ColumnPropNameInRow="GooglePlus1" msprop:Generator_ColumnPropNameInTable="GooglePlus1Column" msprop:Generator_UserColumnName="GooglePlus1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GooglePlus2" msprop:Generator_ColumnVarNameInTable="columnGooglePlus2" msprop:Generator_ColumnPropNameInRow="GooglePlus2" msprop:Generator_ColumnPropNameInTable="GooglePlus2Column" msprop:Generator_UserColumnName="GooglePlus2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GoogleMap" msprop:Generator_ColumnVarNameInTable="columnGoogleMap" msprop:Generator_ColumnPropNameInRow="GoogleMap" msprop:Generator_ColumnPropNameInTable="GoogleMapColumn" msprop:Generator_UserColumnName="GoogleMap" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GoogleMap1" msprop:Generator_ColumnVarNameInTable="columnGoogleMap1" msprop:Generator_ColumnPropNameInRow="GoogleMap1" msprop:Generator_ColumnPropNameInTable="GoogleMap1Column" msprop:Generator_UserColumnName="GoogleMap1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GoogleMap2" msprop:Generator_ColumnVarNameInTable="columnGoogleMap2" msprop:Generator_ColumnPropNameInRow="GoogleMap2" msprop:Generator_ColumnPropNameInTable="GoogleMap2Column" msprop:Generator_UserColumnName="GoogleMap2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GoogleMap3" msprop:Generator_ColumnVarNameInTable="columnGoogleMap3" msprop:Generator_ColumnPropNameInRow="GoogleMap3" msprop:Generator_ColumnPropNameInTable="GoogleMap3Column" msprop:Generator_UserColumnName="GoogleMap3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ProductInCart" msprop:Generator_TableClassName="ProductInCartDataTable" msprop:Generator_TableVarName="tableProductInCart" msprop:Generator_TablePropName="ProductInCart" msprop:Generator_RowDeletingName="ProductInCartRowDeleting" msprop:Generator_RowChangingName="ProductInCartRowChanging" msprop:Generator_RowEvHandlerName="ProductInCartRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductInCartRowDeleted" msprop:Generator_UserTableName="ProductInCart" msprop:Generator_RowChangedName="ProductInCartRowChanged" msprop:Generator_RowEvArgName="ProductInCartRowChangeEvent" msprop:Generator_RowClassName="ProductInCartRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="CartID" msprop:Generator_ColumnVarNameInTable="columnCartID" msprop:Generator_ColumnPropNameInRow="CartID" msprop:Generator_ColumnPropNameInTable="CartIDColumn" msprop:Generator_UserColumnName="CartID" type="xs:int" minOccurs="0" />
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" minOccurs="0" />
              <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Products" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_TableVarName="tableProducts" msprop:Generator_TablePropName="Products" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_UserTableName="Products" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_RowClassName="ProductsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
              <xs:element name="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" msprop:Generator_UserColumnName="Code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title_en" msprop:Generator_ColumnVarNameInTable="columnTitle_en" msprop:Generator_ColumnPropNameInRow="Title_en" msprop:Generator_ColumnPropNameInTable="Title_enColumn" msprop:Generator_UserColumnName="Title_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_en" msprop:Generator_ColumnVarNameInTable="columnDescription_en" msprop:Generator_ColumnPropNameInRow="Description_en" msprop:Generator_ColumnPropNameInTable="Description_enColumn" msprop:Generator_UserColumnName="Description_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Content" msprop:Generator_ColumnVarNameInTable="columnContent" msprop:Generator_ColumnPropNameInRow="Content" msprop:Generator_ColumnPropNameInTable="ContentColumn" msprop:Generator_UserColumnName="Content" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Content_en" msprop:Generator_ColumnVarNameInTable="columnContent_en" msprop:Generator_ColumnPropNameInRow="Content_en" msprop:Generator_ColumnPropNameInTable="Content_enColumn" msprop:Generator_UserColumnName="Content_en" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Link" msprop:Generator_ColumnVarNameInTable="columnLink" msprop:Generator_ColumnPropNameInRow="Link" msprop:Generator_ColumnPropNameInTable="LinkColumn" msprop:Generator_UserColumnName="Link" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VideoUrl" msprop:Generator_ColumnVarNameInTable="columnVideoUrl" msprop:Generator_ColumnPropNameInRow="VideoUrl" msprop:Generator_ColumnPropNameInTable="VideoUrlColumn" msprop:Generator_UserColumnName="VideoUrl" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:double" minOccurs="0" />
              <xs:element name="PriceSale" msprop:Generator_ColumnVarNameInTable="columnPriceSale" msprop:Generator_ColumnPropNameInRow="PriceSale" msprop:Generator_ColumnPropNameInTable="PriceSaleColumn" msprop:Generator_UserColumnName="PriceSale" type="xs:double" minOccurs="0" />
              <xs:element name="CateID" msprop:Generator_ColumnVarNameInTable="columnCateID" msprop:Generator_ColumnPropNameInRow="CateID" msprop:Generator_ColumnPropNameInTable="CateIDColumn" msprop:Generator_UserColumnName="CateID" type="xs:int" minOccurs="0" />
              <xs:element name="AddDate" msprop:Generator_ColumnVarNameInTable="columnAddDate" msprop:Generator_ColumnPropNameInRow="AddDate" msprop:Generator_ColumnPropNameInTable="AddDateColumn" msprop:Generator_UserColumnName="AddDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Editdate" msprop:Generator_ColumnVarNameInTable="columnEditdate" msprop:Generator_ColumnPropNameInRow="Editdate" msprop:Generator_ColumnPropNameInTable="EditdateColumn" msprop:Generator_UserColumnName="Editdate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AddBy" msprop:Generator_ColumnVarNameInTable="columnAddBy" msprop:Generator_ColumnPropNameInRow="AddBy" msprop:Generator_ColumnPropNameInTable="AddByColumn" msprop:Generator_UserColumnName="AddBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="New" msprop:Generator_ColumnVarNameInTable="columnNew" msprop:Generator_ColumnPropNameInRow="New" msprop:Generator_ColumnPropNameInTable="NewColumn" msprop:Generator_UserColumnName="New" type="xs:boolean" minOccurs="0" />
              <xs:element name="Vip" msprop:Generator_ColumnVarNameInTable="columnVip" msprop:Generator_ColumnPropNameInRow="Vip" msprop:Generator_ColumnPropNameInTable="VipColumn" msprop:Generator_UserColumnName="Vip" type="xs:boolean" minOccurs="0" />
              <xs:element name="Sale" msprop:Generator_ColumnVarNameInTable="columnSale" msprop:Generator_ColumnPropNameInRow="Sale" msprop:Generator_ColumnPropNameInTable="SaleColumn" msprop:Generator_UserColumnName="Sale" type="xs:boolean" minOccurs="0" />
              <xs:element name="MetaTitle" msprop:Generator_ColumnVarNameInTable="columnMetaTitle" msprop:Generator_ColumnPropNameInRow="MetaTitle" msprop:Generator_ColumnPropNameInTable="MetaTitleColumn" msprop:Generator_UserColumnName="MetaTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MetaDescription" msprop:Generator_ColumnVarNameInTable="columnMetaDescription" msprop:Generator_ColumnPropNameInRow="MetaDescription" msprop:Generator_ColumnPropNameInTable="MetaDescriptionColumn" msprop:Generator_UserColumnName="MetaDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MetaKeywork" msprop:Generator_ColumnVarNameInTable="columnMetaKeywork" msprop:Generator_ColumnPropNameInRow="MetaKeywork" msprop:Generator_ColumnPropNameInTable="MetaKeyworkColumn" msprop:Generator_UserColumnName="MetaKeywork" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MetaRobots" msprop:Generator_ColumnVarNameInTable="columnMetaRobots" msprop:Generator_ColumnPropNameInRow="MetaRobots" msprop:Generator_ColumnPropNameInTable="MetaRobotsColumn" msprop:Generator_UserColumnName="MetaRobots" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Order" msprop:Generator_ColumnVarNameInTable="columnOrder" msprop:Generator_ColumnPropNameInRow="Order" msprop:Generator_ColumnPropNameInTable="OrderColumn" msprop:Generator_UserColumnName="Order" type="xs:int" minOccurs="0" />
              <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status" type="xs:boolean" minOccurs="0" />
              <xs:element name="Delete" msprop:Generator_ColumnVarNameInTable="columnDelete" msprop:Generator_ColumnPropNameInRow="Delete" msprop:Generator_ColumnPropNameInTable="DeleteColumn" msprop:Generator_UserColumnName="Delete" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Members" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Cart_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cart" />
      <xs:field xpath="mstns:CartID" />
    </xs:unique>
    <xs:unique name="Category_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Category" />
      <xs:field xpath="mstns:CateID" />
    </xs:unique>
    <xs:unique name="Info_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Info" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="ProductInCart_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ProductInCart" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Products_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Products" />
      <xs:field xpath="mstns:ProductID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_ProductInCart_Cart" msdata:parent="Cart" msdata:child="ProductInCart" msdata:parentkey="CartID" msdata:childkey="CartID" msprop:Generator_UserChildTable="ProductInCart" msprop:Generator_ChildPropName="GetProductInCartRows" msprop:Generator_UserRelationName="FK_ProductInCart_Cart" msprop:Generator_ParentPropName="CartRow" msprop:Generator_RelationVarName="relationFK_ProductInCart_Cart" msprop:Generator_UserParentTable="Cart" />
      <msdata:Relationship name="FK_ProductInCart_Products" msdata:parent="Products" msdata:child="ProductInCart" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="ProductInCart" msprop:Generator_ChildPropName="GetProductInCartRows" msprop:Generator_UserRelationName="FK_ProductInCart_Products" msprop:Generator_RelationVarName="relationFK_ProductInCart_Products" msprop:Generator_UserParentTable="Products" msprop:Generator_ParentPropName="ProductsRow" />
      <msdata:Relationship name="FK_Products_Category" msdata:parent="Category" msdata:child="Products" msdata:parentkey="CateID" msdata:childkey="CateID" msprop:Generator_UserChildTable="Products" msprop:Generator_ChildPropName="GetProductsRows" msprop:Generator_UserRelationName="FK_Products_Category" msprop:Generator_ParentPropName="CategoryRow" msprop:Generator_RelationVarName="relationFK_Products_Category" msprop:Generator_UserParentTable="Category" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>